﻿<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/main.Master" CodeBehind="Home.aspx.vb" Inherits="moviesblogspot.Home" 
    title="Untitled Page" %>
  

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
   
   <td>
 
  <style>
      
 .style1
        {
            
            /*background: #c80000 url('images/dt_bg.gif') repeat-x 50% bottom;*/
	color: #74a7b7;
	margin: 2px 2px 1px 2px;
	padding: 6px 0;
	text-align: center;
	font-weight: bold;
	width: 102%;
        height: 343px;
    }
    </style>
                        
              
    <table class="style1" >
        <tr>
<%--            <td>
                 <p><h3 style="color:Black; align:center">WELCOME TO BOLLYWOOD MOVIES BLOGSPOT</h3>
                         </p>
                          
                 <asp:LoginName ID="LoginName1" runat="server" />
                          
                 <br />
                          
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1" CssClass="gridclass3" Width="569px">
        <Columns>
            <asp:CommandField ShowEditButton="True" />
            <asp:BoundField DataField="description" HeaderText="description" 
                SortExpression="description" />
            <asp:BoundField DataField="budjet" HeaderText="budjet" 
                SortExpression="budjet" />
            <asp:BoundField DataField="yearofrelease" HeaderText="yearofrelease" 
                SortExpression="yearofrelease" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MovieConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:MovieConnectionString.ProviderName %>" 
        SelectCommand="SELECT [description], [budjet], [yearofrelease] FROM [moviedetails]"
        updateCommand="update [moviedetails] set descripton=@description where moviename='tees maar khan'">
        
    </asp:SqlDataSource>
 
            </td>--%>
        </tr>
        <tr><td>
        
            <br />
            <asp:Label ID="Label1" runat="server" BackColor="Maroon" BorderColor="Black" 
                BorderStyle="Dashed" ForeColor="Blue" Text="LIST OF MOVIES"></asp:Label>
            <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <br />
        
            <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource2" CaptionAlign="Top" CellPadding="4" 
                ForeColor="#333333" GridLines="None" HorizontalAlign="Center">
                <AlternatingRowStyle BackColor="White" />
        <Columns>

            <asp:HyperLinkField DataNavigateUrlFields="movieid" 
                DataNavigateUrlFormatString="Details.aspx?movieid={0}" 
                DataTextField="moviename" HeaderText="Movies" />
        </Columns>
                <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                <SortedAscendingCellStyle BackColor="#FDF5AC" />
                <SortedAscendingHeaderStyle BackColor="#4D0000" />
                <SortedDescendingCellStyle BackColor="#FCF6C0" />
                <SortedDescendingHeaderStyle BackColor="#820000" />
    </asp:GridView>
            <br />
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MovieConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:MovieConnectionString.ProviderName %>" 
        SelectCommand="SELECT [movieid],[categories_id], [moviename] FROM [movies] WHERE ([categories_id] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="id1" QueryStringField="id1" 
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
        
        </td></tr>
    </table>
 
  </td> 

              
</asp:Content>
